Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

PostgreSQL
1) Aggregate Functions
2) Analytical Functions
3) Array
4) Constraints
5) Cursor
6) Data Type
7) Database
8) Date Timezone
9) Index
10) Inheritance
11) Insert Delete Update
12) Math Functions
13) Postgre SQL
14) Select Query
15) Sequence
16) Store Procedure Function
17) String Functions
18) Subquery
19) Table
20) Table Joins
21) Transaction
22) User Previliege
23) View

Select Query
1) A simple WHERE clause
2) A verbose explanation of a simpler query, with the VERBOSE keyword
3) Aggregate function, group by and having
4) Case when statement
5) Cast row function
6) Combining comparisons with Boolean operators
7) Combining conditions in the WHERE clause
8) Comparing strings
9) Comparing two rows
10) Comparison operators with AND
11) Comparisons equal to NULL
12) Comparisons using IS NULL
13) Correct operator usage
14) DISTINCT ON
15) Duplicate rows be removed from the result of a query
16) Executing EXPLAIN for a query
17) Group by and having
18) Grouping WHERE conditions with parentheses
19) Insert string with quotation
20) Is a shorthand for all columns
21) Like with single wild card char
22) Like with wild card char
23) NATURAL JOIN works with LIMIT and OFFSET
24) NOT for boolean value
25) Observing NULL values
26) Operator equivalents to BETWEEN
27) Operator Precedence Demo
28) Order by in ascending order
29) Pass row function to function
30) Row Constructors
31) Select constant value
32) SELECT text a AS text UNION SELECT b
33) Specify the table columns in a select statement
34) Specifying Target Columns
35) Type Resolution in a Transposed Union
36) Use subquery in where statement
37) Using AND in where clause
38) Using BETWEEN
39) Using case expressions in statements
40) Using comparison operators
41) Using DISTINCT
42) Using DISTINCT and ORDER BY together
43) Using DISTINCT with ORDER BY
44) Using EXCEPT for two data sets
45) Using expressions
46) Using expressions and constants
47) Using function in subquery in where statement
48) Using INTERSECT for two data sets
49) Using LIMIT for Natural Join
50) Using Mathematical Operators
51) Using operators with NULL values
52) Using OR in where clause
53) Using ORDER BY
54) Using ORDER BY with multiple expressions
55) Using Row function in a function
56) Using SELECT INTO
57) Using the HAVING clause with inner join
58) Using UNION for two data sets
59) WHERE clause contains a Boolean (truth value) expression